home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Excel for Windows 95 Bible by John Walkenbach
/
Excel For Windows 95 Bible by John Walkenbach (IDG Books) (1-56884-495-6)(1995).ISO
/
xl_sw
/
dpr_shed
/
deprec8.txt
next >
Wrap
Text File
|
1995-05-27
|
4KB
|
90 lines
Deprec8 ver 1.02 for Microsoft Excel versions 4 and 5
Generate Depreciation Schedules
Deprec8 is a MS Excel macro application that generates
depreciation schedules for tax and book purposes. For tax
purposes, it uses the IRS defined Modified Accelerated Cost
Recovery System (MACRS) to calculate annual depreciation
amounts. For tax purposes, most tangible depreciable
property placed in service after 1986 must be depreciated
under MACRS. Deprec8 gives you the option of using the
MACRS half-year or mid-quarter convention for property
being "depreciated over 3, 5, 7, 10, 15 or 20 years.
Schedules for 27.5 and 39 years use the IRS defined MACRS
mid-month convention. For book purposes, Deprec8
generates schedules of any duration with either straight
line, double declining balance or the sum of the years
digits method. Deprec8 handles fiscal years that do not
follow the calendar year, and salvage values for book
purposes.
Deprec8 can not eliminate the need for consulting advice
from an accountant. Ohio Star Software is not responsible
for any problems caused by the improper use of this
software, the improper application of accounting principles
or the violation of tax laws.
How to use Deprec8.xlm
Running Deprec8.xlm is easy. Deprec8.xlm is a Microsoft
Excel macro that runs automatically when opened by Excel.
Deprec8.xlm can also be re-started during the same Excel
session by pressing Ctrl-Shift-A (for the input screen) or
Ctrl-Shift-Z (for the introductory screen).
When you load Deprec8.xlm, you will see an introductory
screen. Select "Generate a Depreciation Schedule" to go on
to the input screen. The input screen is used to provide
basic information about the asset (value, desc, etc...). When
you have all fields completed and select "OK" the macro will
generate a depreciation schedule based on the information
provided.
Registration Information
Deprec8.xlm is not completely functional in it distributed
shareware form. For tax purposes, it will only generate a
10 year schedule. For book purposes, it will only generate
straight line depreciation schedules. If you would like to
have the tool generate other lengths of tax purpose
schedules or a double declining balance schedule, you will
need to register the product.
Registration Levels
Level 1: $10.00 You will receive the Full Function Password
required to generate all of the possible schedule
lengths and types. If you only have a couple of
assets to account for then this is the best way to go.
Level 2: $25.00 You will receive the commercial
(non-shareware) version of this product without
password protection on the macro itself. This will
allow you to have complete control over how the
schedules are generated and you won't have to enter a
password to generate a schedule. You will be able to
modify the macro source code to customize the generated
schedules for your business. If you need to generate a
lot of schedules and you need them customized for your
business, this is the best way to go.
To register this product, send the appropriate registration
amount ($10 or $25) to:
Ohio Star Software
Deprec8.xlm 1.02 Registration
8919 Deep Forest Ln.
Centerville, OH 45458
For faster service with level 1 registrations, mail the $10.00
check to the address below and send us an e-mail message saying
"the check is in the mail for Deprec8 ver 1.02". We will reply to
your e-mail with the Full Function Password and wait for your
check to arrive.
E-Mail Addresses:
CompuServe ID: 70412,2455
Internet: 70412.2455@compuserve.com